| Number of Variables | 13 |
|---|---|
| Number of Rows | 105120 |
| Missing Cells | 0 |
| Missing Cells (%) | 0.0% |
| Duplicate Rows | 0 |
| Duplicate Rows (%) | 0.0% |
| Total Size in Memory | 18.6 MB |
| Average Row Size in Memory | 186.0 B |
| Variable Types |
|
| dpt_1_2_Prod_kW is skewed | Skewed |
|---|---|
| enerpos_Prod_kW is skewed | Skewed |
| esiroi_Prod_kW is skewed | Skewed |
| GHI is skewed | Skewed |
| BNI is skewed | Skewed |
| DHI is skewed | Skewed |
| Ws10 is skewed | Skewed |
| Wd10 is skewed | Skewed |
| Rainfall is skewed | Skewed |
| datetime has a high cardinality: 105120 distinct values | High Cardinality |
| datetime has constant length 25 | Constant Length |
|---|---|
| datetime has all distinct values | Unique |
| dpt_1_2_Prod_kW has 51731 (49.21%) negatives | Negatives |
| esiroi_Prod_kW has 53826 (51.2%) negatives | Negatives |
| enerpos_Prod_kW has 53916 (51.29%) zeros | Zeros |
| GHI has 49372 (46.97%) zeros | Zeros |
| BNI has 48926 (46.54%) zeros | Zeros |
| DHI has 50060 (47.62%) zeros | Zeros |
| Rainfall has 102238 (97.26%) zeros | Zeros |
categorical
| Approximate Distinct Count | 105120 |
|---|---|
| Approximate Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 9460800 |
| Mean | 25 |
|---|---|
| Standard Deviation | 0 |
| Median | 25 |
| Minimum | 25 |
| Maximum | 25 |
| 1st row | 2021-01-01 00:10:0... |
|---|---|
| 2nd row | 2021-01-01 00:20:0... |
| 3rd row | 2021-01-01 00:30:0... |
| 4th row | 2021-01-01 00:40:0... |
| 5th row | 2021-01-01 00:50:0... |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 105120 |
| Uppercase Letter | 0 |
| Dash Punctuation | 210240 |
| Decimal Number | 1892160 |
numerical
| Approximate Distinct Count | 53482 |
|---|---|
| Approximate Unique (%) | 50.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 20.5312 |
| Minimum | -0.02257 |
| Maximum | 100.98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 51731 |
| Negatives (%) | 49.2% |
| Minimum | -0.02257 |
|---|---|
| 5-th Percentile | -0.02257 |
| Q1 | -0.02257 |
| Median | 0.1718 |
| Q3 | 40.1365 |
| 95-th Percentile | 78.7548 |
| Maximum | 100.98 |
| Range | 101.0026 |
| IQR | 40.159 |
| Mean | 20.5312 |
|---|---|
| Standard Deviation | 28.4899 |
| Variance | 811.6757 |
| Sum | 2.1582e+06 |
| Skewness | 1.0794 |
| Kurtosis | -0.3419 |
| Coefficient of Variation | 1.3876 |
numerical
| Approximate Distinct Count | 51126 |
|---|---|
| Approximate Unique (%) | 48.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 8.3283 |
| Minimum | -0.02191 |
| Maximum | 44.852 |
| Zeros | 53916 |
| Zeros (%) | 51.3% |
| Negatives | 104 |
| Negatives (%) | 0.1% |
| Minimum | -0.02191 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 16.3202 |
| 95-th Percentile | 32.5664 |
| Maximum | 44.852 |
| Range | 44.8739 |
| IQR | 16.3202 |
| Mean | 8.3283 |
|---|---|
| Standard Deviation | 11.5866 |
| Variance | 134.2496 |
| Sum | 875466.667 |
| Skewness | 1.1249 |
| Kurtosis | -0.1159 |
| Coefficient of Variation | 1.3912 |
numerical
| Approximate Distinct Count | 51429 |
|---|---|
| Approximate Unique (%) | 48.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 1.9045 |
| Minimum | -0.005061 |
| Maximum | 9.3546 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 53826 |
| Negatives (%) | 51.2% |
| Minimum | -0.005061 |
|---|---|
| 5-th Percentile | -0.002254 |
| Q1 | -0.002254 |
| Median | -0.002254 |
| Q3 | 3.7718 |
| 95-th Percentile | 7.2804 |
| Maximum | 9.3546 |
| Range | 9.3596 |
| IQR | 3.7741 |
| Mean | 1.9045 |
|---|---|
| Standard Deviation | 2.6454 |
| Variance | 6.9982 |
| Sum | 200197.2815 |
| Skewness | 1.0599 |
| Kurtosis | -0.4139 |
| Coefficient of Variation | 1.3891 |
numerical
| Approximate Distinct Count | 43308 |
|---|---|
| Approximate Unique (%) | 41.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 236.8802 |
| Minimum | 0 |
| Maximum | 1305.9 |
| Zeros | 49372 |
| Zeros (%) | 47.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 3.8998 |
| Q3 | 451.6675 |
| 95-th Percentile | 933.6 |
| Maximum | 1305.9 |
| Range | 1305.9 |
| IQR | 451.6675 |
| Mean | 236.8802 |
|---|---|
| Standard Deviation | 328.7519 |
| Variance | 108077.8041 |
| Sum | 2.4901e+07 |
| Skewness | 1.1488 |
| Kurtosis | -0.04371 |
| Coefficient of Variation | 1.3878 |
numerical
| Approximate Distinct Count | 42520 |
|---|---|
| Approximate Unique (%) | 40.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 223.8563 |
| Minimum | 0 |
| Maximum | 1200.8944 |
| Zeros | 48926 |
| Zeros (%) | 46.5% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0.1685 |
| Q3 | 518.7525 |
| 95-th Percentile | 849 |
| Maximum | 1200.8944 |
| Range | 1200.8944 |
| IQR | 518.7525 |
| Mean | 223.8563 |
|---|---|
| Standard Deviation | 328.6593 |
| Variance | 108016.9263 |
| Sum | 2.3532e+07 |
| Skewness | 1.0116 |
| Kurtosis | -0.7233 |
| Coefficient of Variation | 1.4682 |
numerical
| Approximate Distinct Count | 44000 |
|---|---|
| Approximate Unique (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 81.6965 |
| Minimum | 0 |
| Maximum | 1046.9 |
| Zeros | 50060 |
| Zeros (%) | 47.6% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 3.558 |
| Q3 | 124.2225 |
| 95-th Percentile | 354.7415 |
| Maximum | 1046.9 |
| Range | 1046.9 |
| IQR | 124.2225 |
| Mean | 81.6965 |
|---|---|
| Standard Deviation | 122.2309 |
| Variance | 14940.4048 |
| Sum | 8.5879e+06 |
| Skewness | 1.9736 |
| Kurtosis | 4.3107 |
| Coefficient of Variation | 1.4962 |
numerical
| Approximate Distinct Count | 15874 |
|---|---|
| Approximate Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 23.7785 |
| Minimum | 14.297 |
| Maximum | 33.992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 14.297 |
|---|---|
| 5-th Percentile | 17.93 |
| Q1 | 20.954 |
| Median | 23.918 |
| Q3 | 26.341 |
| 95-th Percentile | 29.711 |
| Maximum | 33.992 |
| Range | 19.695 |
| IQR | 5.387 |
| Mean | 23.7785 |
|---|---|
| Standard Deviation | 3.5856 |
| Variance | 12.8564 |
| Sum | 2.4996e+06 |
| Skewness | -0.004845 |
| Kurtosis | -0.7083 |
| Coefficient of Variation | 0.1508 |
numerical
| Approximate Distinct Count | 28147 |
|---|---|
| Approximate Unique (%) | 26.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 74.2615 |
| Minimum | 0.08495 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0.08495 |
|---|---|
| 5-th Percentile | 57.1399 |
| Q1 | 67.075 |
| Median | 74.5005 |
| Q3 | 81.58 |
| 95-th Percentile | 90.88 |
| Maximum | 100 |
| Range | 99.9151 |
| IQR | 14.505 |
| Mean | 74.2615 |
|---|---|
| Standard Deviation | 10.1714 |
| Variance | 103.4568 |
| Sum | 7.8064e+06 |
| Skewness | -0.1428 |
| Kurtosis | -0.3036 |
| Coefficient of Variation | 0.137 |
numerical
| Approximate Distinct Count | 47617 |
|---|---|
| Approximate Unique (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 2.3113 |
| Minimum | 0 |
| Maximum | 13.207 |
| Zeros | 570 |
| Zeros (%) | 0.5% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0.103 |
| Q1 | 0.6972 |
| Median | 1.8975 |
| Q3 | 3.4613 |
| 95-th Percentile | 6.0781 |
| Maximum | 13.207 |
| Range | 13.207 |
| IQR | 2.7641 |
| Mean | 2.3113 |
|---|---|
| Standard Deviation | 1.9371 |
| Variance | 3.7523 |
| Sum | 242959.227 |
| Skewness | 0.8962 |
| Kurtosis | 0.2558 |
| Coefficient of Variation | 0.8381 |
numerical
| Approximate Distinct Count | 55669 |
|---|---|
| Approximate Unique (%) | 53.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 122.588 |
| Minimum | 0.0824 |
| Maximum | 356.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0.0824 |
|---|---|
| 5-th Percentile | 42.5476 |
| Q1 | 90.22 |
| Median | 113.36 |
| Q3 | 135.5217 |
| 95-th Percentile | 248.0624 |
| Maximum | 356.48 |
| Range | 356.3976 |
| IQR | 45.3017 |
| Mean | 122.588 |
|---|---|
| Standard Deviation | 58.6729 |
| Variance | 3442.5086 |
| Sum | 1.2886e+07 |
| Skewness | 1.0658 |
| Kurtosis | 1.2078 |
| Coefficient of Variation | 0.4786 |
numerical
| Approximate Distinct Count | 951 |
|---|---|
| Approximate Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 1017.3305 |
| Minimum | 995.4 |
| Maximum | 1028 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 995.4 |
|---|---|
| 5-th Percentile | 1010 |
| Q1 | 1014 |
| Median | 1017.4 |
| Q3 | 1021 |
| 95-th Percentile | 1024 |
| Maximum | 1028 |
| Range | 32.6 |
| IQR | 7 |
| Mean | 1017.3305 |
|---|---|
| Standard Deviation | 4.6391 |
| Variance | 21.5216 |
| Sum | 1.0694e+08 |
| Skewness | -0.3029 |
| Kurtosis | -0.09134 |
| Coefficient of Variation | 0.00456 |
numerical
| Approximate Distinct Count | 39 |
|---|---|
| Approximate Unique (%) | 0.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 1681920 |
| Mean | 0.001471 |
| Minimum | 0 |
| Maximum | 1.32 |
| Zeros | 102238 |
| Zeros (%) | 97.3% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th Percentile | 0 |
| Maximum | 1.32 |
| Range | 1.32 |
| IQR | 0 |
| Mean | 0.001471 |
|---|---|
| Standard Deviation | 0.01635 |
| Variance | 0.00026732 |
| Sum | 154.66 |
| Skewness | 29.1593 |
| Kurtosis | 1361.4423 |
| Coefficient of Variation | 11.1129 |